Freetds introduction, installation, configuration and usage, freetds Introduction
What is FreeTDS?In short, FreeTDS is a library that allows you to access Microsoft's SQL database in Linux! FreeTDS is an open-source Library (if you like it, you can
Two sets of DataSource, whose server settings are the same, but clientcharset is set to UTF-8 and GB2312.
1. install unixODBC
Download the installation package.UnixODBC-2.2.11-1.RHEL4.1.i386.rpmUnixODBC-devel-2.2.11-1.RHEL4.1.i386.rpmUnixODBC-kde-2.2
1. Install the unixODBC download installation package. There is a unixODBC-2.2.11-1.RHEL4.1.i386.rpmunixODBC-devel-2.2.11-1.RHEL4.1. I ON THE RedHat installation disc
1. Install the unixODBC download installation package. There is a unixODBC-2.2.11-1
Install and configure freetds-connect to msssql in Linux
Connecting to MSSQL in Linux is very painful because Microsoft does not provide any interfaces to developers. They think that MSSQL is only a Windows operating system. Fortunately, MSSQL is
I recently used C ++ in Linux to connect to SQL Server 2005 in windows, so I had to use freetds.
Environment: System ubuntu9.04 kernel 2.6.28 GCC 4.3.3 freetds 0.91
Freetds's latest stable version is 0.91, this can download http://www.freetds.org/on
Because of the work we need to access our previous SQL Server 2005 data through PHP, so we have the birth of this article. Nonsense is less, do programming the least like to beat around the bush. Use the introduction steps to explain the problem and
What is FreeTDSSimply put, FreeTDS is a library that enables access to Microsoft's SQL database under Linux systems! FreeTDS is an open source (if you prefer to be called free) of the library, is the TDS (table column data stream) protocol is
Install freetds in Ubuntu to access sysbase and Microsoft SQL Server databases.
To access sqlserver in Linux, use freetds!
: Http://www.freetds.org
CD: Enter the directory where freetds is located. (For example, CD/root/usr/local/freetds) there
In the case of php5.3, The dblib driver of pdo cannot connect to mssql. According to the official description, 5.2 has modified this bug, but 5.3 does not. You can use the mssql function provided by php.
In the case of php5.3, The dblib driver of
1. Download: freetds-patched.tar.gz http://www.freetds.org/software.htmlHttp://www.freetds.org/userguide/choosingtdsprotocol.htm# TAR-ZXVF Freetds-patched.tar.gz# CD freetds-1.00.21Note that this is the--with-tdsver=7.4, this is very important, you
In CentOS 5.4 Linux, PHP (FastCGI) needs to connect to the SQL Server 2000 database of the relevant department and configure the extended FreeTDS extension.
1. Compile and install FreeTDS
mkdir -p /data0/software/
cd /data0/software/
PHP on Linux even MSSQL, using UNIXODBC + FreeTDS Installation steps: Installing UNIXODBC Yum Install UnixODBCYum Install Unixodbc-devel Installing FreeTDS
SQL SQL statements and stored procedures for SQL Server execution with FreeTDS under LinuxHttp://www.linuxidc.com/Linux/2012-06/61617.htmFreeTDS relatedHttp://www.knowsky.com/616936.htmlThe shell accepts the value returned by the stored
PHP on Linux even MSSQL, using UNIXODBC + FreeTDS
Installation steps:
Installing UNIXODBC
Yum Install UnixODBCYum Install Unixodbc-devel
Installing FreeTDS
Installing UNIXODBCUse PYODBC to install UNIXODBC on LinuxUnixodbc-devel packages can be installed with Yum or aptCompile and install: http://www.unixodbc.org/download.htmlSuccessful Installation verification#odbcinst-2.3. 7
php5.3 case, with PDO Dblib driver can not connect MSSQL, according to the official description, 5.2 has modified this bug,5.3 No.It is possible to use the MSSQL function that comes with PHP. Compile the Freetds,php_mssql,pdo_dblib parameters as
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.